package com.javasoft.dao.ZSW;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.javasoft.entity.ZSW.PersonalExamAnalysisEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface PersonalExamAnalysisDao extends BaseMapper<PersonalExamAnalysisEntity> {
    //从 student_answer 表中查找出 student_id 和 exam_id 分别等于传入的对应参数值的所有记录，并且返回这些记录
    @Select("SELECT * FROM student_answer WHERE student_id = #{student_id} AND exam_id = #{exam_id}")
    PersonalExamAnalysisEntity findscore(@Param("student_id") Integer student_id, @Param("exam_id") Integer exam_id);
}